Steps to Geocode in Awesome table
- Upload and open in or copy the contents of “ua_populations.csv” in Google Sheets
- Filter the sheet to only show 2011 data so that we end up with a single entry for each UA

Copy the first 2 rows and paste into a new sheet.
In new sheet, create a column called “country” and fill the first cell with “India”. Select all cells below it and fill them all with India too (Select all cells including first cell with India -> Ctrl/CMD + D)
- Find and replace all instances of “U.A” with blank space (Be careful to add the period otherwise names will get changed)
- Go to “Add-ons” in the menu bar -> “Get Add-Ons” -> Search for “Geocode by Awesome Table” and install it
Once it installs, go to “Add-ons” in the menu bar -> “Geocode by Awesome Table” -> “Start Geocoding”
Choose the “address in multiple columns option and choose”ua" and “country”, what this will do is create a new column "Full Address that will have the city and country concatenated.
- Make sure “Full address is your Address Column and click”Geocode!". This will create two columns, Latitude and Longitude that we will use.
- Please bear in mind this might not be very exact. One mistake it makes is Nanded-Waghala, UA number 91. We shall correct this manually for now - Latitude 19.1383, Longitude 77.321
- Download the current sheet as a “.csv” and move it to the data/spatial_data folder with the name “ua_geocode.csv”